package com.things8.iot.baseIot.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

/**
 * @author  yzh
 * @date  2021/5/9 22:59
 * @version 1.0
 */
public class SysDeviceExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public SysDeviceExample() {
        oredCriteria = new ArrayList<>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andSysidIsNull() {
            addCriterion("`sysId` is null");
            return (Criteria) this;
        }

        public Criteria andSysidIsNotNull() {
            addCriterion("`sysId` is not null");
            return (Criteria) this;
        }

        public Criteria andSysidEqualTo(Long value) {
            addCriterion("`sysId` =", value, "sysid");
            return (Criteria) this;
        }

        public Criteria andSysidNotEqualTo(Long value) {
            addCriterion("`sysId` <>", value, "sysid");
            return (Criteria) this;
        }

        public Criteria andSysidGreaterThan(Long value) {
            addCriterion("`sysId` >", value, "sysid");
            return (Criteria) this;
        }

        public Criteria andSysidGreaterThanOrEqualTo(Long value) {
            addCriterion("`sysId` >=", value, "sysid");
            return (Criteria) this;
        }

        public Criteria andSysidLessThan(Long value) {
            addCriterion("`sysId` <", value, "sysid");
            return (Criteria) this;
        }

        public Criteria andSysidLessThanOrEqualTo(Long value) {
            addCriterion("`sysId` <=", value, "sysid");
            return (Criteria) this;
        }

        public Criteria andSysidIn(List<Long> values) {
            addCriterion("`sysId` in", values, "sysid");
            return (Criteria) this;
        }

        public Criteria andSysidNotIn(List<Long> values) {
            addCriterion("`sysId` not in", values, "sysid");
            return (Criteria) this;
        }

        public Criteria andSysidBetween(Long value1, Long value2) {
            addCriterion("`sysId` between", value1, value2, "sysid");
            return (Criteria) this;
        }

        public Criteria andSysidNotBetween(Long value1, Long value2) {
            addCriterion("`sysId` not between", value1, value2, "sysid");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("`name` is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("`name` is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("`name` =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("`name` <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("`name` >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("`name` >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("`name` <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("`name` <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("`name` like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("`name` not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("`name` in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("`name` not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("`name` between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("`name` not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andSerialnumberIsNull() {
            addCriterion("serialnumber is null");
            return (Criteria) this;
        }

        public Criteria andSerialnumberIsNotNull() {
            addCriterion("serialnumber is not null");
            return (Criteria) this;
        }

        public Criteria andSerialnumberEqualTo(String value) {
            addCriterion("serialnumber =", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberNotEqualTo(String value) {
            addCriterion("serialnumber <>", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberGreaterThan(String value) {
            addCriterion("serialnumber >", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberGreaterThanOrEqualTo(String value) {
            addCriterion("serialnumber >=", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberLessThan(String value) {
            addCriterion("serialnumber <", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberLessThanOrEqualTo(String value) {
            addCriterion("serialnumber <=", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberLike(String value) {
            addCriterion("serialnumber like", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberNotLike(String value) {
            addCriterion("serialnumber not like", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberIn(List<String> values) {
            addCriterion("serialnumber in", values, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberNotIn(List<String> values) {
            addCriterion("serialnumber not in", values, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberBetween(String value1, String value2) {
            addCriterion("serialnumber between", value1, value2, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberNotBetween(String value1, String value2) {
            addCriterion("serialnumber not between", value1, value2, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andDevicemodelidIsNull() {
            addCriterion("deviceModelId is null");
            return (Criteria) this;
        }

        public Criteria andDevicemodelidIsNotNull() {
            addCriterion("deviceModelId is not null");
            return (Criteria) this;
        }

        public Criteria andDevicemodelidEqualTo(Long value) {
            addCriterion("deviceModelId =", value, "devicemodelid");
            return (Criteria) this;
        }

        public Criteria andDevicemodelidNotEqualTo(Long value) {
            addCriterion("deviceModelId <>", value, "devicemodelid");
            return (Criteria) this;
        }

        public Criteria andDevicemodelidGreaterThan(Long value) {
            addCriterion("deviceModelId >", value, "devicemodelid");
            return (Criteria) this;
        }

        public Criteria andDevicemodelidGreaterThanOrEqualTo(Long value) {
            addCriterion("deviceModelId >=", value, "devicemodelid");
            return (Criteria) this;
        }

        public Criteria andDevicemodelidLessThan(Long value) {
            addCriterion("deviceModelId <", value, "devicemodelid");
            return (Criteria) this;
        }

        public Criteria andDevicemodelidLessThanOrEqualTo(Long value) {
            addCriterion("deviceModelId <=", value, "devicemodelid");
            return (Criteria) this;
        }

        public Criteria andDevicemodelidIn(List<Long> values) {
            addCriterion("deviceModelId in", values, "devicemodelid");
            return (Criteria) this;
        }

        public Criteria andDevicemodelidNotIn(List<Long> values) {
            addCriterion("deviceModelId not in", values, "devicemodelid");
            return (Criteria) this;
        }

        public Criteria andDevicemodelidBetween(Long value1, Long value2) {
            addCriterion("deviceModelId between", value1, value2, "devicemodelid");
            return (Criteria) this;
        }

        public Criteria andDevicemodelidNotBetween(Long value1, Long value2) {
            addCriterion("deviceModelId not between", value1, value2, "devicemodelid");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("`status` is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("`status` is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("`status` =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("`status` <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("`status` >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("`status` >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("`status` <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("`status` <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("`status` like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("`status` not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("`status` in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("`status` not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("`status` between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("`status` not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andComaddressIsNull() {
            addCriterion("comaddress is null");
            return (Criteria) this;
        }

        public Criteria andComaddressIsNotNull() {
            addCriterion("comaddress is not null");
            return (Criteria) this;
        }

        public Criteria andComaddressEqualTo(String value) {
            addCriterion("comaddress =", value, "comaddress");
            return (Criteria) this;
        }

        public Criteria andComaddressNotEqualTo(String value) {
            addCriterion("comaddress <>", value, "comaddress");
            return (Criteria) this;
        }

        public Criteria andComaddressGreaterThan(String value) {
            addCriterion("comaddress >", value, "comaddress");
            return (Criteria) this;
        }

        public Criteria andComaddressGreaterThanOrEqualTo(String value) {
            addCriterion("comaddress >=", value, "comaddress");
            return (Criteria) this;
        }

        public Criteria andComaddressLessThan(String value) {
            addCriterion("comaddress <", value, "comaddress");
            return (Criteria) this;
        }

        public Criteria andComaddressLessThanOrEqualTo(String value) {
            addCriterion("comaddress <=", value, "comaddress");
            return (Criteria) this;
        }

        public Criteria andComaddressLike(String value) {
            addCriterion("comaddress like", value, "comaddress");
            return (Criteria) this;
        }

        public Criteria andComaddressNotLike(String value) {
            addCriterion("comaddress not like", value, "comaddress");
            return (Criteria) this;
        }

        public Criteria andComaddressIn(List<String> values) {
            addCriterion("comaddress in", values, "comaddress");
            return (Criteria) this;
        }

        public Criteria andComaddressNotIn(List<String> values) {
            addCriterion("comaddress not in", values, "comaddress");
            return (Criteria) this;
        }

        public Criteria andComaddressBetween(String value1, String value2) {
            addCriterion("comaddress between", value1, value2, "comaddress");
            return (Criteria) this;
        }

        public Criteria andComaddressNotBetween(String value1, String value2) {
            addCriterion("comaddress not between", value1, value2, "comaddress");
            return (Criteria) this;
        }

        public Criteria andModelIsNull() {
            addCriterion("model is null");
            return (Criteria) this;
        }

        public Criteria andModelIsNotNull() {
            addCriterion("model is not null");
            return (Criteria) this;
        }

        public Criteria andModelEqualTo(String value) {
            addCriterion("model =", value, "model");
            return (Criteria) this;
        }

        public Criteria andModelNotEqualTo(String value) {
            addCriterion("model <>", value, "model");
            return (Criteria) this;
        }

        public Criteria andModelGreaterThan(String value) {
            addCriterion("model >", value, "model");
            return (Criteria) this;
        }

        public Criteria andModelGreaterThanOrEqualTo(String value) {
            addCriterion("model >=", value, "model");
            return (Criteria) this;
        }

        public Criteria andModelLessThan(String value) {
            addCriterion("model <", value, "model");
            return (Criteria) this;
        }

        public Criteria andModelLessThanOrEqualTo(String value) {
            addCriterion("model <=", value, "model");
            return (Criteria) this;
        }

        public Criteria andModelLike(String value) {
            addCriterion("model like", value, "model");
            return (Criteria) this;
        }

        public Criteria andModelNotLike(String value) {
            addCriterion("model not like", value, "model");
            return (Criteria) this;
        }

        public Criteria andModelIn(List<String> values) {
            addCriterion("model in", values, "model");
            return (Criteria) this;
        }

        public Criteria andModelNotIn(List<String> values) {
            addCriterion("model not in", values, "model");
            return (Criteria) this;
        }

        public Criteria andModelBetween(String value1, String value2) {
            addCriterion("model between", value1, value2, "model");
            return (Criteria) this;
        }

        public Criteria andModelNotBetween(String value1, String value2) {
            addCriterion("model not between", value1, value2, "model");
            return (Criteria) this;
        }

        public Criteria andVendoridIsNull() {
            addCriterion("vendorId is null");
            return (Criteria) this;
        }

        public Criteria andVendoridIsNotNull() {
            addCriterion("vendorId is not null");
            return (Criteria) this;
        }

        public Criteria andVendoridEqualTo(Long value) {
            addCriterion("vendorId =", value, "vendorid");
            return (Criteria) this;
        }

        public Criteria andVendoridNotEqualTo(Long value) {
            addCriterion("vendorId <>", value, "vendorid");
            return (Criteria) this;
        }

        public Criteria andVendoridGreaterThan(Long value) {
            addCriterion("vendorId >", value, "vendorid");
            return (Criteria) this;
        }

        public Criteria andVendoridGreaterThanOrEqualTo(Long value) {
            addCriterion("vendorId >=", value, "vendorid");
            return (Criteria) this;
        }

        public Criteria andVendoridLessThan(Long value) {
            addCriterion("vendorId <", value, "vendorid");
            return (Criteria) this;
        }

        public Criteria andVendoridLessThanOrEqualTo(Long value) {
            addCriterion("vendorId <=", value, "vendorid");
            return (Criteria) this;
        }

        public Criteria andVendoridIn(List<Long> values) {
            addCriterion("vendorId in", values, "vendorid");
            return (Criteria) this;
        }

        public Criteria andVendoridNotIn(List<Long> values) {
            addCriterion("vendorId not in", values, "vendorid");
            return (Criteria) this;
        }

        public Criteria andVendoridBetween(Long value1, Long value2) {
            addCriterion("vendorId between", value1, value2, "vendorid");
            return (Criteria) this;
        }

        public Criteria andVendoridNotBetween(Long value1, Long value2) {
            addCriterion("vendorId not between", value1, value2, "vendorid");
            return (Criteria) this;
        }

        public Criteria andGatewayidIsNull() {
            addCriterion("gatewayId is null");
            return (Criteria) this;
        }

        public Criteria andGatewayidIsNotNull() {
            addCriterion("gatewayId is not null");
            return (Criteria) this;
        }

        public Criteria andGatewayidEqualTo(Long value) {
            addCriterion("gatewayId =", value, "gatewayid");
            return (Criteria) this;
        }

        public Criteria andGatewayidNotEqualTo(Long value) {
            addCriterion("gatewayId <>", value, "gatewayid");
            return (Criteria) this;
        }

        public Criteria andGatewayidGreaterThan(Long value) {
            addCriterion("gatewayId >", value, "gatewayid");
            return (Criteria) this;
        }

        public Criteria andGatewayidGreaterThanOrEqualTo(Long value) {
            addCriterion("gatewayId >=", value, "gatewayid");
            return (Criteria) this;
        }

        public Criteria andGatewayidLessThan(Long value) {
            addCriterion("gatewayId <", value, "gatewayid");
            return (Criteria) this;
        }

        public Criteria andGatewayidLessThanOrEqualTo(Long value) {
            addCriterion("gatewayId <=", value, "gatewayid");
            return (Criteria) this;
        }

        public Criteria andGatewayidIn(List<Long> values) {
            addCriterion("gatewayId in", values, "gatewayid");
            return (Criteria) this;
        }

        public Criteria andGatewayidNotIn(List<Long> values) {
            addCriterion("gatewayId not in", values, "gatewayid");
            return (Criteria) this;
        }

        public Criteria andGatewayidBetween(Long value1, Long value2) {
            addCriterion("gatewayId between", value1, value2, "gatewayid");
            return (Criteria) this;
        }

        public Criteria andGatewayidNotBetween(Long value1, Long value2) {
            addCriterion("gatewayId not between", value1, value2, "gatewayid");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andNetidIsNull() {
            addCriterion("netId is null");
            return (Criteria) this;
        }

        public Criteria andNetidIsNotNull() {
            addCriterion("netId is not null");
            return (Criteria) this;
        }

        public Criteria andNetidEqualTo(String value) {
            addCriterion("netId =", value, "netid");
            return (Criteria) this;
        }

        public Criteria andNetidNotEqualTo(String value) {
            addCriterion("netId <>", value, "netid");
            return (Criteria) this;
        }

        public Criteria andNetidGreaterThan(String value) {
            addCriterion("netId >", value, "netid");
            return (Criteria) this;
        }

        public Criteria andNetidGreaterThanOrEqualTo(String value) {
            addCriterion("netId >=", value, "netid");
            return (Criteria) this;
        }

        public Criteria andNetidLessThan(String value) {
            addCriterion("netId <", value, "netid");
            return (Criteria) this;
        }

        public Criteria andNetidLessThanOrEqualTo(String value) {
            addCriterion("netId <=", value, "netid");
            return (Criteria) this;
        }

        public Criteria andNetidLike(String value) {
            addCriterion("netId like", value, "netid");
            return (Criteria) this;
        }

        public Criteria andNetidNotLike(String value) {
            addCriterion("netId not like", value, "netid");
            return (Criteria) this;
        }

        public Criteria andNetidIn(List<String> values) {
            addCriterion("netId in", values, "netid");
            return (Criteria) this;
        }

        public Criteria andNetidNotIn(List<String> values) {
            addCriterion("netId not in", values, "netid");
            return (Criteria) this;
        }

        public Criteria andNetidBetween(String value1, String value2) {
            addCriterion("netId between", value1, value2, "netid");
            return (Criteria) this;
        }

        public Criteria andNetidNotBetween(String value1, String value2) {
            addCriterion("netId not between", value1, value2, "netid");
            return (Criteria) this;
        }

        public Criteria andPortIsNull() {
            addCriterion("port is null");
            return (Criteria) this;
        }

        public Criteria andPortIsNotNull() {
            addCriterion("port is not null");
            return (Criteria) this;
        }

        public Criteria andPortEqualTo(String value) {
            addCriterion("port =", value, "port");
            return (Criteria) this;
        }

        public Criteria andPortNotEqualTo(String value) {
            addCriterion("port <>", value, "port");
            return (Criteria) this;
        }

        public Criteria andPortGreaterThan(String value) {
            addCriterion("port >", value, "port");
            return (Criteria) this;
        }

        public Criteria andPortGreaterThanOrEqualTo(String value) {
            addCriterion("port >=", value, "port");
            return (Criteria) this;
        }

        public Criteria andPortLessThan(String value) {
            addCriterion("port <", value, "port");
            return (Criteria) this;
        }

        public Criteria andPortLessThanOrEqualTo(String value) {
            addCriterion("port <=", value, "port");
            return (Criteria) this;
        }

        public Criteria andPortLike(String value) {
            addCriterion("port like", value, "port");
            return (Criteria) this;
        }

        public Criteria andPortNotLike(String value) {
            addCriterion("port not like", value, "port");
            return (Criteria) this;
        }

        public Criteria andPortIn(List<String> values) {
            addCriterion("port in", values, "port");
            return (Criteria) this;
        }

        public Criteria andPortNotIn(List<String> values) {
            addCriterion("port not in", values, "port");
            return (Criteria) this;
        }

        public Criteria andPortBetween(String value1, String value2) {
            addCriterion("port between", value1, value2, "port");
            return (Criteria) this;
        }

        public Criteria andPortNotBetween(String value1, String value2) {
            addCriterion("port not between", value1, value2, "port");
            return (Criteria) this;
        }

        public Criteria andCloudidIsNull() {
            addCriterion("cloudId is null");
            return (Criteria) this;
        }

        public Criteria andCloudidIsNotNull() {
            addCriterion("cloudId is not null");
            return (Criteria) this;
        }

        public Criteria andCloudidEqualTo(String value) {
            addCriterion("cloudId =", value, "cloudid");
            return (Criteria) this;
        }

        public Criteria andCloudidNotEqualTo(String value) {
            addCriterion("cloudId <>", value, "cloudid");
            return (Criteria) this;
        }

        public Criteria andCloudidGreaterThan(String value) {
            addCriterion("cloudId >", value, "cloudid");
            return (Criteria) this;
        }

        public Criteria andCloudidGreaterThanOrEqualTo(String value) {
            addCriterion("cloudId >=", value, "cloudid");
            return (Criteria) this;
        }

        public Criteria andCloudidLessThan(String value) {
            addCriterion("cloudId <", value, "cloudid");
            return (Criteria) this;
        }

        public Criteria andCloudidLessThanOrEqualTo(String value) {
            addCriterion("cloudId <=", value, "cloudid");
            return (Criteria) this;
        }

        public Criteria andCloudidLike(String value) {
            addCriterion("cloudId like", value, "cloudid");
            return (Criteria) this;
        }

        public Criteria andCloudidNotLike(String value) {
            addCriterion("cloudId not like", value, "cloudid");
            return (Criteria) this;
        }

        public Criteria andCloudidIn(List<String> values) {
            addCriterion("cloudId in", values, "cloudid");
            return (Criteria) this;
        }

        public Criteria andCloudidNotIn(List<String> values) {
            addCriterion("cloudId not in", values, "cloudid");
            return (Criteria) this;
        }

        public Criteria andCloudidBetween(String value1, String value2) {
            addCriterion("cloudId between", value1, value2, "cloudid");
            return (Criteria) this;
        }

        public Criteria andCloudidNotBetween(String value1, String value2) {
            addCriterion("cloudId not between", value1, value2, "cloudid");
            return (Criteria) this;
        }

        public Criteria andIconIsNull() {
            addCriterion("icon is null");
            return (Criteria) this;
        }

        public Criteria andIconIsNotNull() {
            addCriterion("icon is not null");
            return (Criteria) this;
        }

        public Criteria andIconEqualTo(String value) {
            addCriterion("icon =", value, "icon");
            return (Criteria) this;
        }

        public Criteria andIconNotEqualTo(String value) {
            addCriterion("icon <>", value, "icon");
            return (Criteria) this;
        }

        public Criteria andIconGreaterThan(String value) {
            addCriterion("icon >", value, "icon");
            return (Criteria) this;
        }

        public Criteria andIconGreaterThanOrEqualTo(String value) {
            addCriterion("icon >=", value, "icon");
            return (Criteria) this;
        }

        public Criteria andIconLessThan(String value) {
            addCriterion("icon <", value, "icon");
            return (Criteria) this;
        }

        public Criteria andIconLessThanOrEqualTo(String value) {
            addCriterion("icon <=", value, "icon");
            return (Criteria) this;
        }

        public Criteria andIconLike(String value) {
            addCriterion("icon like", value, "icon");
            return (Criteria) this;
        }

        public Criteria andIconNotLike(String value) {
            addCriterion("icon not like", value, "icon");
            return (Criteria) this;
        }

        public Criteria andIconIn(List<String> values) {
            addCriterion("icon in", values, "icon");
            return (Criteria) this;
        }

        public Criteria andIconNotIn(List<String> values) {
            addCriterion("icon not in", values, "icon");
            return (Criteria) this;
        }

        public Criteria andIconBetween(String value1, String value2) {
            addCriterion("icon between", value1, value2, "icon");
            return (Criteria) this;
        }

        public Criteria andIconNotBetween(String value1, String value2) {
            addCriterion("icon not between", value1, value2, "icon");
            return (Criteria) this;
        }

        public Criteria andLongtitudeIsNull() {
            addCriterion("longtitude is null");
            return (Criteria) this;
        }

        public Criteria andLongtitudeIsNotNull() {
            addCriterion("longtitude is not null");
            return (Criteria) this;
        }

        public Criteria andLongtitudeEqualTo(String value) {
            addCriterion("longtitude =", value, "longtitude");
            return (Criteria) this;
        }

        public Criteria andLongtitudeNotEqualTo(String value) {
            addCriterion("longtitude <>", value, "longtitude");
            return (Criteria) this;
        }

        public Criteria andLongtitudeGreaterThan(String value) {
            addCriterion("longtitude >", value, "longtitude");
            return (Criteria) this;
        }

        public Criteria andLongtitudeGreaterThanOrEqualTo(String value) {
            addCriterion("longtitude >=", value, "longtitude");
            return (Criteria) this;
        }

        public Criteria andLongtitudeLessThan(String value) {
            addCriterion("longtitude <", value, "longtitude");
            return (Criteria) this;
        }

        public Criteria andLongtitudeLessThanOrEqualTo(String value) {
            addCriterion("longtitude <=", value, "longtitude");
            return (Criteria) this;
        }

        public Criteria andLongtitudeLike(String value) {
            addCriterion("longtitude like", value, "longtitude");
            return (Criteria) this;
        }

        public Criteria andLongtitudeNotLike(String value) {
            addCriterion("longtitude not like", value, "longtitude");
            return (Criteria) this;
        }

        public Criteria andLongtitudeIn(List<String> values) {
            addCriterion("longtitude in", values, "longtitude");
            return (Criteria) this;
        }

        public Criteria andLongtitudeNotIn(List<String> values) {
            addCriterion("longtitude not in", values, "longtitude");
            return (Criteria) this;
        }

        public Criteria andLongtitudeBetween(String value1, String value2) {
            addCriterion("longtitude between", value1, value2, "longtitude");
            return (Criteria) this;
        }

        public Criteria andLongtitudeNotBetween(String value1, String value2) {
            addCriterion("longtitude not between", value1, value2, "longtitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeIsNull() {
            addCriterion("latitude is null");
            return (Criteria) this;
        }

        public Criteria andLatitudeIsNotNull() {
            addCriterion("latitude is not null");
            return (Criteria) this;
        }

        public Criteria andLatitudeEqualTo(String value) {
            addCriterion("latitude =", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeNotEqualTo(String value) {
            addCriterion("latitude <>", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeGreaterThan(String value) {
            addCriterion("latitude >", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeGreaterThanOrEqualTo(String value) {
            addCriterion("latitude >=", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeLessThan(String value) {
            addCriterion("latitude <", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeLessThanOrEqualTo(String value) {
            addCriterion("latitude <=", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeLike(String value) {
            addCriterion("latitude like", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeNotLike(String value) {
            addCriterion("latitude not like", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeIn(List<String> values) {
            addCriterion("latitude in", values, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeNotIn(List<String> values) {
            addCriterion("latitude not in", values, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeBetween(String value1, String value2) {
            addCriterion("latitude between", value1, value2, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeNotBetween(String value1, String value2) {
            addCriterion("latitude not between", value1, value2, "latitude");
            return (Criteria) this;
        }

        public Criteria andOwnercountIsNull() {
            addCriterion("ownercount is null");
            return (Criteria) this;
        }

        public Criteria andOwnercountIsNotNull() {
            addCriterion("ownercount is not null");
            return (Criteria) this;
        }

        public Criteria andOwnercountEqualTo(Integer value) {
            addCriterion("ownercount =", value, "ownercount");
            return (Criteria) this;
        }

        public Criteria andOwnercountNotEqualTo(Integer value) {
            addCriterion("ownercount <>", value, "ownercount");
            return (Criteria) this;
        }

        public Criteria andOwnercountGreaterThan(Integer value) {
            addCriterion("ownercount >", value, "ownercount");
            return (Criteria) this;
        }

        public Criteria andOwnercountGreaterThanOrEqualTo(Integer value) {
            addCriterion("ownercount >=", value, "ownercount");
            return (Criteria) this;
        }

        public Criteria andOwnercountLessThan(Integer value) {
            addCriterion("ownercount <", value, "ownercount");
            return (Criteria) this;
        }

        public Criteria andOwnercountLessThanOrEqualTo(Integer value) {
            addCriterion("ownercount <=", value, "ownercount");
            return (Criteria) this;
        }

        public Criteria andOwnercountIn(List<Integer> values) {
            addCriterion("ownercount in", values, "ownercount");
            return (Criteria) this;
        }

        public Criteria andOwnercountNotIn(List<Integer> values) {
            addCriterion("ownercount not in", values, "ownercount");
            return (Criteria) this;
        }

        public Criteria andOwnercountBetween(Integer value1, Integer value2) {
            addCriterion("ownercount between", value1, value2, "ownercount");
            return (Criteria) this;
        }

        public Criteria andOwnercountNotBetween(Integer value1, Integer value2) {
            addCriterion("ownercount not between", value1, value2, "ownercount");
            return (Criteria) this;
        }

        public Criteria andCreattimeIsNull() {
            addCriterion("creatTime is null");
            return (Criteria) this;
        }

        public Criteria andCreattimeIsNotNull() {
            addCriterion("creatTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreattimeEqualTo(Date value) {
            addCriterion("creatTime =", value, "creattime");
            return (Criteria) this;
        }

        public Criteria andCreattimeNotEqualTo(Date value) {
            addCriterion("creatTime <>", value, "creattime");
            return (Criteria) this;
        }

        public Criteria andCreattimeGreaterThan(Date value) {
            addCriterion("creatTime >", value, "creattime");
            return (Criteria) this;
        }

        public Criteria andCreattimeGreaterThanOrEqualTo(Date value) {
            addCriterion("creatTime >=", value, "creattime");
            return (Criteria) this;
        }

        public Criteria andCreattimeLessThan(Date value) {
            addCriterion("creatTime <", value, "creattime");
            return (Criteria) this;
        }

        public Criteria andCreattimeLessThanOrEqualTo(Date value) {
            addCriterion("creatTime <=", value, "creattime");
            return (Criteria) this;
        }

        public Criteria andCreattimeIn(List<Date> values) {
            addCriterion("creatTime in", values, "creattime");
            return (Criteria) this;
        }

        public Criteria andCreattimeNotIn(List<Date> values) {
            addCriterion("creatTime not in", values, "creattime");
            return (Criteria) this;
        }

        public Criteria andCreattimeBetween(Date value1, Date value2) {
            addCriterion("creatTime between", value1, value2, "creattime");
            return (Criteria) this;
        }

        public Criteria andCreattimeNotBetween(Date value1, Date value2) {
            addCriterion("creatTime not between", value1, value2, "creattime");
            return (Criteria) this;
        }

        public Criteria andCmdIsNull() {
            addCriterion("cmd is null");
            return (Criteria) this;
        }

        public Criteria andCmdIsNotNull() {
            addCriterion("cmd is not null");
            return (Criteria) this;
        }

        public Criteria andCmdEqualTo(String value) {
            addCriterion("cmd =", value, "cmd");
            return (Criteria) this;
        }

        public Criteria andCmdNotEqualTo(String value) {
            addCriterion("cmd <>", value, "cmd");
            return (Criteria) this;
        }

        public Criteria andCmdGreaterThan(String value) {
            addCriterion("cmd >", value, "cmd");
            return (Criteria) this;
        }

        public Criteria andCmdGreaterThanOrEqualTo(String value) {
            addCriterion("cmd >=", value, "cmd");
            return (Criteria) this;
        }

        public Criteria andCmdLessThan(String value) {
            addCriterion("cmd <", value, "cmd");
            return (Criteria) this;
        }

        public Criteria andCmdLessThanOrEqualTo(String value) {
            addCriterion("cmd <=", value, "cmd");
            return (Criteria) this;
        }

        public Criteria andCmdLike(String value) {
            addCriterion("cmd like", value, "cmd");
            return (Criteria) this;
        }

        public Criteria andCmdNotLike(String value) {
            addCriterion("cmd not like", value, "cmd");
            return (Criteria) this;
        }

        public Criteria andCmdIn(List<String> values) {
            addCriterion("cmd in", values, "cmd");
            return (Criteria) this;
        }

        public Criteria andCmdNotIn(List<String> values) {
            addCriterion("cmd not in", values, "cmd");
            return (Criteria) this;
        }

        public Criteria andCmdBetween(String value1, String value2) {
            addCriterion("cmd between", value1, value2, "cmd");
            return (Criteria) this;
        }

        public Criteria andCmdNotBetween(String value1, String value2) {
            addCriterion("cmd not between", value1, value2, "cmd");
            return (Criteria) this;
        }

        public Criteria andFormatIsNull() {
            addCriterion("format is null");
            return (Criteria) this;
        }

        public Criteria andFormatIsNotNull() {
            addCriterion("format is not null");
            return (Criteria) this;
        }

        public Criteria andFormatEqualTo(String value) {
            addCriterion("format =", value, "format");
            return (Criteria) this;
        }

        public Criteria andFormatNotEqualTo(String value) {
            addCriterion("format <>", value, "format");
            return (Criteria) this;
        }

        public Criteria andFormatGreaterThan(String value) {
            addCriterion("format >", value, "format");
            return (Criteria) this;
        }

        public Criteria andFormatGreaterThanOrEqualTo(String value) {
            addCriterion("format >=", value, "format");
            return (Criteria) this;
        }

        public Criteria andFormatLessThan(String value) {
            addCriterion("format <", value, "format");
            return (Criteria) this;
        }

        public Criteria andFormatLessThanOrEqualTo(String value) {
            addCriterion("format <=", value, "format");
            return (Criteria) this;
        }

        public Criteria andFormatLike(String value) {
            addCriterion("format like", value, "format");
            return (Criteria) this;
        }

        public Criteria andFormatNotLike(String value) {
            addCriterion("format not like", value, "format");
            return (Criteria) this;
        }

        public Criteria andFormatIn(List<String> values) {
            addCriterion("format in", values, "format");
            return (Criteria) this;
        }

        public Criteria andFormatNotIn(List<String> values) {
            addCriterion("format not in", values, "format");
            return (Criteria) this;
        }

        public Criteria andFormatBetween(String value1, String value2) {
            addCriterion("format between", value1, value2, "format");
            return (Criteria) this;
        }

        public Criteria andFormatNotBetween(String value1, String value2) {
            addCriterion("format not between", value1, value2, "format");
            return (Criteria) this;
        }

        public Criteria andExpressionIsNull() {
            addCriterion("expression is null");
            return (Criteria) this;
        }

        public Criteria andExpressionIsNotNull() {
            addCriterion("expression is not null");
            return (Criteria) this;
        }

        public Criteria andExpressionEqualTo(String value) {
            addCriterion("expression =", value, "expression");
            return (Criteria) this;
        }

        public Criteria andExpressionNotEqualTo(String value) {
            addCriterion("expression <>", value, "expression");
            return (Criteria) this;
        }

        public Criteria andExpressionGreaterThan(String value) {
            addCriterion("expression >", value, "expression");
            return (Criteria) this;
        }

        public Criteria andExpressionGreaterThanOrEqualTo(String value) {
            addCriterion("expression >=", value, "expression");
            return (Criteria) this;
        }

        public Criteria andExpressionLessThan(String value) {
            addCriterion("expression <", value, "expression");
            return (Criteria) this;
        }

        public Criteria andExpressionLessThanOrEqualTo(String value) {
            addCriterion("expression <=", value, "expression");
            return (Criteria) this;
        }

        public Criteria andExpressionLike(String value) {
            addCriterion("expression like", value, "expression");
            return (Criteria) this;
        }

        public Criteria andExpressionNotLike(String value) {
            addCriterion("expression not like", value, "expression");
            return (Criteria) this;
        }

        public Criteria andExpressionIn(List<String> values) {
            addCriterion("expression in", values, "expression");
            return (Criteria) this;
        }

        public Criteria andExpressionNotIn(List<String> values) {
            addCriterion("expression not in", values, "expression");
            return (Criteria) this;
        }

        public Criteria andExpressionBetween(String value1, String value2) {
            addCriterion("expression between", value1, value2, "expression");
            return (Criteria) this;
        }

        public Criteria andExpressionNotBetween(String value1, String value2) {
            addCriterion("expression not between", value1, value2, "expression");
            return (Criteria) this;
        }

        public Criteria andPositionIsNull() {
            addCriterion("`position` is null");
            return (Criteria) this;
        }

        public Criteria andPositionIsNotNull() {
            addCriterion("`position` is not null");
            return (Criteria) this;
        }

        public Criteria andPositionEqualTo(Integer value) {
            addCriterion("`position` =", value, "position");
            return (Criteria) this;
        }

        public Criteria andPositionNotEqualTo(Integer value) {
            addCriterion("`position` <>", value, "position");
            return (Criteria) this;
        }

        public Criteria andPositionGreaterThan(Integer value) {
            addCriterion("`position` >", value, "position");
            return (Criteria) this;
        }

        public Criteria andPositionGreaterThanOrEqualTo(Integer value) {
            addCriterion("`position` >=", value, "position");
            return (Criteria) this;
        }

        public Criteria andPositionLessThan(Integer value) {
            addCriterion("`position` <", value, "position");
            return (Criteria) this;
        }

        public Criteria andPositionLessThanOrEqualTo(Integer value) {
            addCriterion("`position` <=", value, "position");
            return (Criteria) this;
        }

        public Criteria andPositionIn(List<Integer> values) {
            addCriterion("`position` in", values, "position");
            return (Criteria) this;
        }

        public Criteria andPositionNotIn(List<Integer> values) {
            addCriterion("`position` not in", values, "position");
            return (Criteria) this;
        }

        public Criteria andPositionBetween(Integer value1, Integer value2) {
            addCriterion("`position` between", value1, value2, "position");
            return (Criteria) this;
        }

        public Criteria andPositionNotBetween(Integer value1, Integer value2) {
            addCriterion("`position` not between", value1, value2, "position");
            return (Criteria) this;
        }

        public Criteria andTablenameIsNull() {
            addCriterion("tablename is null");
            return (Criteria) this;
        }

        public Criteria andTablenameIsNotNull() {
            addCriterion("tablename is not null");
            return (Criteria) this;
        }

        public Criteria andTablenameEqualTo(String value) {
            addCriterion("tablename =", value, "tablename");
            return (Criteria) this;
        }

        public Criteria andTablenameNotEqualTo(String value) {
            addCriterion("tablename <>", value, "tablename");
            return (Criteria) this;
        }

        public Criteria andTablenameGreaterThan(String value) {
            addCriterion("tablename >", value, "tablename");
            return (Criteria) this;
        }

        public Criteria andTablenameGreaterThanOrEqualTo(String value) {
            addCriterion("tablename >=", value, "tablename");
            return (Criteria) this;
        }

        public Criteria andTablenameLessThan(String value) {
            addCriterion("tablename <", value, "tablename");
            return (Criteria) this;
        }

        public Criteria andTablenameLessThanOrEqualTo(String value) {
            addCriterion("tablename <=", value, "tablename");
            return (Criteria) this;
        }

        public Criteria andTablenameLike(String value) {
            addCriterion("tablename like", value, "tablename");
            return (Criteria) this;
        }

        public Criteria andTablenameNotLike(String value) {
            addCriterion("tablename not like", value, "tablename");
            return (Criteria) this;
        }

        public Criteria andTablenameIn(List<String> values) {
            addCriterion("tablename in", values, "tablename");
            return (Criteria) this;
        }

        public Criteria andTablenameNotIn(List<String> values) {
            addCriterion("tablename not in", values, "tablename");
            return (Criteria) this;
        }

        public Criteria andTablenameBetween(String value1, String value2) {
            addCriterion("tablename between", value1, value2, "tablename");
            return (Criteria) this;
        }

        public Criteria andTablenameNotBetween(String value1, String value2) {
            addCriterion("tablename not between", value1, value2, "tablename");
            return (Criteria) this;
        }

        public Criteria andCpatternIsNull() {
            addCriterion("cpattern is null");
            return (Criteria) this;
        }

        public Criteria andCpatternIsNotNull() {
            addCriterion("cpattern is not null");
            return (Criteria) this;
        }

        public Criteria andCpatternEqualTo(String value) {
            addCriterion("cpattern =", value, "cpattern");
            return (Criteria) this;
        }

        public Criteria andCpatternNotEqualTo(String value) {
            addCriterion("cpattern <>", value, "cpattern");
            return (Criteria) this;
        }

        public Criteria andCpatternGreaterThan(String value) {
            addCriterion("cpattern >", value, "cpattern");
            return (Criteria) this;
        }

        public Criteria andCpatternGreaterThanOrEqualTo(String value) {
            addCriterion("cpattern >=", value, "cpattern");
            return (Criteria) this;
        }

        public Criteria andCpatternLessThan(String value) {
            addCriterion("cpattern <", value, "cpattern");
            return (Criteria) this;
        }

        public Criteria andCpatternLessThanOrEqualTo(String value) {
            addCriterion("cpattern <=", value, "cpattern");
            return (Criteria) this;
        }

        public Criteria andCpatternLike(String value) {
            addCriterion("cpattern like", value, "cpattern");
            return (Criteria) this;
        }

        public Criteria andCpatternNotLike(String value) {
            addCriterion("cpattern not like", value, "cpattern");
            return (Criteria) this;
        }

        public Criteria andCpatternIn(List<String> values) {
            addCriterion("cpattern in", values, "cpattern");
            return (Criteria) this;
        }

        public Criteria andCpatternNotIn(List<String> values) {
            addCriterion("cpattern not in", values, "cpattern");
            return (Criteria) this;
        }

        public Criteria andCpatternBetween(String value1, String value2) {
            addCriterion("cpattern between", value1, value2, "cpattern");
            return (Criteria) this;
        }

        public Criteria andCpatternNotBetween(String value1, String value2) {
            addCriterion("cpattern not between", value1, value2, "cpattern");
            return (Criteria) this;
        }

        public Criteria andCollectionIsNull() {
            addCriterion("`collection` is null");
            return (Criteria) this;
        }

        public Criteria andCollectionIsNotNull() {
            addCriterion("`collection` is not null");
            return (Criteria) this;
        }

        public Criteria andCollectionEqualTo(String value) {
            addCriterion("`collection` =", value, "collection");
            return (Criteria) this;
        }

        public Criteria andCollectionNotEqualTo(String value) {
            addCriterion("`collection` <>", value, "collection");
            return (Criteria) this;
        }

        public Criteria andCollectionGreaterThan(String value) {
            addCriterion("`collection` >", value, "collection");
            return (Criteria) this;
        }

        public Criteria andCollectionGreaterThanOrEqualTo(String value) {
            addCriterion("`collection` >=", value, "collection");
            return (Criteria) this;
        }

        public Criteria andCollectionLessThan(String value) {
            addCriterion("`collection` <", value, "collection");
            return (Criteria) this;
        }

        public Criteria andCollectionLessThanOrEqualTo(String value) {
            addCriterion("`collection` <=", value, "collection");
            return (Criteria) this;
        }

        public Criteria andCollectionLike(String value) {
            addCriterion("`collection` like", value, "collection");
            return (Criteria) this;
        }

        public Criteria andCollectionNotLike(String value) {
            addCriterion("`collection` not like", value, "collection");
            return (Criteria) this;
        }

        public Criteria andCollectionIn(List<String> values) {
            addCriterion("`collection` in", values, "collection");
            return (Criteria) this;
        }

        public Criteria andCollectionNotIn(List<String> values) {
            addCriterion("`collection` not in", values, "collection");
            return (Criteria) this;
        }

        public Criteria andCollectionBetween(String value1, String value2) {
            addCriterion("`collection` between", value1, value2, "collection");
            return (Criteria) this;
        }

        public Criteria andCollectionNotBetween(String value1, String value2) {
            addCriterion("`collection` not between", value1, value2, "collection");
            return (Criteria) this;
        }

        public Criteria andOfflinetimeIsNull() {
            addCriterion("offlineTime is null");
            return (Criteria) this;
        }

        public Criteria andOfflinetimeIsNotNull() {
            addCriterion("offlineTime is not null");
            return (Criteria) this;
        }

        public Criteria andOfflinetimeEqualTo(Integer value) {
            addCriterion("offlineTime =", value, "offlinetime");
            return (Criteria) this;
        }

        public Criteria andOfflinetimeNotEqualTo(Integer value) {
            addCriterion("offlineTime <>", value, "offlinetime");
            return (Criteria) this;
        }

        public Criteria andOfflinetimeGreaterThan(Integer value) {
            addCriterion("offlineTime >", value, "offlinetime");
            return (Criteria) this;
        }

        public Criteria andOfflinetimeGreaterThanOrEqualTo(Integer value) {
            addCriterion("offlineTime >=", value, "offlinetime");
            return (Criteria) this;
        }

        public Criteria andOfflinetimeLessThan(Integer value) {
            addCriterion("offlineTime <", value, "offlinetime");
            return (Criteria) this;
        }

        public Criteria andOfflinetimeLessThanOrEqualTo(Integer value) {
            addCriterion("offlineTime <=", value, "offlinetime");
            return (Criteria) this;
        }

        public Criteria andOfflinetimeIn(List<Integer> values) {
            addCriterion("offlineTime in", values, "offlinetime");
            return (Criteria) this;
        }

        public Criteria andOfflinetimeNotIn(List<Integer> values) {
            addCriterion("offlineTime not in", values, "offlinetime");
            return (Criteria) this;
        }

        public Criteria andOfflinetimeBetween(Integer value1, Integer value2) {
            addCriterion("offlineTime between", value1, value2, "offlinetime");
            return (Criteria) this;
        }

        public Criteria andOfflinetimeNotBetween(Integer value1, Integer value2) {
            addCriterion("offlineTime not between", value1, value2, "offlinetime");
            return (Criteria) this;
        }

        public Criteria andSecretIsNull() {
            addCriterion("secret is null");
            return (Criteria) this;
        }

        public Criteria andSecretIsNotNull() {
            addCriterion("secret is not null");
            return (Criteria) this;
        }

        public Criteria andSecretEqualTo(String value) {
            addCriterion("secret =", value, "secret");
            return (Criteria) this;
        }

        public Criteria andSecretNotEqualTo(String value) {
            addCriterion("secret <>", value, "secret");
            return (Criteria) this;
        }

        public Criteria andSecretGreaterThan(String value) {
            addCriterion("secret >", value, "secret");
            return (Criteria) this;
        }

        public Criteria andSecretGreaterThanOrEqualTo(String value) {
            addCriterion("secret >=", value, "secret");
            return (Criteria) this;
        }

        public Criteria andSecretLessThan(String value) {
            addCriterion("secret <", value, "secret");
            return (Criteria) this;
        }

        public Criteria andSecretLessThanOrEqualTo(String value) {
            addCriterion("secret <=", value, "secret");
            return (Criteria) this;
        }

        public Criteria andSecretLike(String value) {
            addCriterion("secret like", value, "secret");
            return (Criteria) this;
        }

        public Criteria andSecretNotLike(String value) {
            addCriterion("secret not like", value, "secret");
            return (Criteria) this;
        }

        public Criteria andSecretIn(List<String> values) {
            addCriterion("secret in", values, "secret");
            return (Criteria) this;
        }

        public Criteria andSecretNotIn(List<String> values) {
            addCriterion("secret not in", values, "secret");
            return (Criteria) this;
        }

        public Criteria andSecretBetween(String value1, String value2) {
            addCriterion("secret between", value1, value2, "secret");
            return (Criteria) this;
        }

        public Criteria andSecretNotBetween(String value1, String value2) {
            addCriterion("secret not between", value1, value2, "secret");
            return (Criteria) this;
        }

        public Criteria andIotidIsNull() {
            addCriterion("iotid is null");
            return (Criteria) this;
        }

        public Criteria andIotidIsNotNull() {
            addCriterion("iotid is not null");
            return (Criteria) this;
        }

        public Criteria andIotidEqualTo(String value) {
            addCriterion("iotid =", value, "iotid");
            return (Criteria) this;
        }

        public Criteria andIotidNotEqualTo(String value) {
            addCriterion("iotid <>", value, "iotid");
            return (Criteria) this;
        }

        public Criteria andIotidGreaterThan(String value) {
            addCriterion("iotid >", value, "iotid");
            return (Criteria) this;
        }

        public Criteria andIotidGreaterThanOrEqualTo(String value) {
            addCriterion("iotid >=", value, "iotid");
            return (Criteria) this;
        }

        public Criteria andIotidLessThan(String value) {
            addCriterion("iotid <", value, "iotid");
            return (Criteria) this;
        }

        public Criteria andIotidLessThanOrEqualTo(String value) {
            addCriterion("iotid <=", value, "iotid");
            return (Criteria) this;
        }

        public Criteria andIotidLike(String value) {
            addCriterion("iotid like", value, "iotid");
            return (Criteria) this;
        }

        public Criteria andIotidNotLike(String value) {
            addCriterion("iotid not like", value, "iotid");
            return (Criteria) this;
        }

        public Criteria andIotidIn(List<String> values) {
            addCriterion("iotid in", values, "iotid");
            return (Criteria) this;
        }

        public Criteria andIotidNotIn(List<String> values) {
            addCriterion("iotid not in", values, "iotid");
            return (Criteria) this;
        }

        public Criteria andIotidBetween(String value1, String value2) {
            addCriterion("iotid between", value1, value2, "iotid");
            return (Criteria) this;
        }

        public Criteria andIotidNotBetween(String value1, String value2) {
            addCriterion("iotid not between", value1, value2, "iotid");
            return (Criteria) this;
        }

        public Criteria andActiveIsNull() {
            addCriterion("active is null");
            return (Criteria) this;
        }

        public Criteria andActiveIsNotNull() {
            addCriterion("active is not null");
            return (Criteria) this;
        }

        public Criteria andActiveEqualTo(Integer value) {
            addCriterion("active =", value, "active");
            return (Criteria) this;
        }

        public Criteria andActiveNotEqualTo(Integer value) {
            addCriterion("active <>", value, "active");
            return (Criteria) this;
        }

        public Criteria andActiveGreaterThan(Integer value) {
            addCriterion("active >", value, "active");
            return (Criteria) this;
        }

        public Criteria andActiveGreaterThanOrEqualTo(Integer value) {
            addCriterion("active >=", value, "active");
            return (Criteria) this;
        }

        public Criteria andActiveLessThan(Integer value) {
            addCriterion("active <", value, "active");
            return (Criteria) this;
        }

        public Criteria andActiveLessThanOrEqualTo(Integer value) {
            addCriterion("active <=", value, "active");
            return (Criteria) this;
        }

        public Criteria andActiveIn(List<Integer> values) {
            addCriterion("active in", values, "active");
            return (Criteria) this;
        }

        public Criteria andActiveNotIn(List<Integer> values) {
            addCriterion("active not in", values, "active");
            return (Criteria) this;
        }

        public Criteria andActiveBetween(Integer value1, Integer value2) {
            addCriterion("active between", value1, value2, "active");
            return (Criteria) this;
        }

        public Criteria andActiveNotBetween(Integer value1, Integer value2) {
            addCriterion("active not between", value1, value2, "active");
            return (Criteria) this;
        }

        public Criteria andValiditymonthIsNull() {
            addCriterion("validityMonth is null");
            return (Criteria) this;
        }

        public Criteria andValiditymonthIsNotNull() {
            addCriterion("validityMonth is not null");
            return (Criteria) this;
        }

        public Criteria andValiditymonthEqualTo(Integer value) {
            addCriterion("validityMonth =", value, "validitymonth");
            return (Criteria) this;
        }

        public Criteria andValiditymonthNotEqualTo(Integer value) {
            addCriterion("validityMonth <>", value, "validitymonth");
            return (Criteria) this;
        }

        public Criteria andValiditymonthGreaterThan(Integer value) {
            addCriterion("validityMonth >", value, "validitymonth");
            return (Criteria) this;
        }

        public Criteria andValiditymonthGreaterThanOrEqualTo(Integer value) {
            addCriterion("validityMonth >=", value, "validitymonth");
            return (Criteria) this;
        }

        public Criteria andValiditymonthLessThan(Integer value) {
            addCriterion("validityMonth <", value, "validitymonth");
            return (Criteria) this;
        }

        public Criteria andValiditymonthLessThanOrEqualTo(Integer value) {
            addCriterion("validityMonth <=", value, "validitymonth");
            return (Criteria) this;
        }

        public Criteria andValiditymonthIn(List<Integer> values) {
            addCriterion("validityMonth in", values, "validitymonth");
            return (Criteria) this;
        }

        public Criteria andValiditymonthNotIn(List<Integer> values) {
            addCriterion("validityMonth not in", values, "validitymonth");
            return (Criteria) this;
        }

        public Criteria andValiditymonthBetween(Integer value1, Integer value2) {
            addCriterion("validityMonth between", value1, value2, "validitymonth");
            return (Criteria) this;
        }

        public Criteria andValiditymonthNotBetween(Integer value1, Integer value2) {
            addCriterion("validityMonth not between", value1, value2, "validitymonth");
            return (Criteria) this;
        }

        public Criteria andActivatetimeIsNull() {
            addCriterion("activateTime is null");
            return (Criteria) this;
        }

        public Criteria andActivatetimeIsNotNull() {
            addCriterion("activateTime is not null");
            return (Criteria) this;
        }

        public Criteria andActivatetimeEqualTo(Date value) {
            addCriterion("activateTime =", value, "activatetime");
            return (Criteria) this;
        }

        public Criteria andActivatetimeNotEqualTo(Date value) {
            addCriterion("activateTime <>", value, "activatetime");
            return (Criteria) this;
        }

        public Criteria andActivatetimeGreaterThan(Date value) {
            addCriterion("activateTime >", value, "activatetime");
            return (Criteria) this;
        }

        public Criteria andActivatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("activateTime >=", value, "activatetime");
            return (Criteria) this;
        }

        public Criteria andActivatetimeLessThan(Date value) {
            addCriterion("activateTime <", value, "activatetime");
            return (Criteria) this;
        }

        public Criteria andActivatetimeLessThanOrEqualTo(Date value) {
            addCriterion("activateTime <=", value, "activatetime");
            return (Criteria) this;
        }

        public Criteria andActivatetimeIn(List<Date> values) {
            addCriterion("activateTime in", values, "activatetime");
            return (Criteria) this;
        }

        public Criteria andActivatetimeNotIn(List<Date> values) {
            addCriterion("activateTime not in", values, "activatetime");
            return (Criteria) this;
        }

        public Criteria andActivatetimeBetween(Date value1, Date value2) {
            addCriterion("activateTime between", value1, value2, "activatetime");
            return (Criteria) this;
        }

        public Criteria andActivatetimeNotBetween(Date value1, Date value2) {
            addCriterion("activateTime not between", value1, value2, "activatetime");
            return (Criteria) this;
        }

        public Criteria andAlarmIsNull() {
            addCriterion("alarm is null");
            return (Criteria) this;
        }

        public Criteria andAlarmIsNotNull() {
            addCriterion("alarm is not null");
            return (Criteria) this;
        }

        public Criteria andAlarmEqualTo(Integer value) {
            addCriterion("alarm =", value, "alarm");
            return (Criteria) this;
        }

        public Criteria andAlarmNotEqualTo(Integer value) {
            addCriterion("alarm <>", value, "alarm");
            return (Criteria) this;
        }

        public Criteria andAlarmGreaterThan(Integer value) {
            addCriterion("alarm >", value, "alarm");
            return (Criteria) this;
        }

        public Criteria andAlarmGreaterThanOrEqualTo(Integer value) {
            addCriterion("alarm >=", value, "alarm");
            return (Criteria) this;
        }

        public Criteria andAlarmLessThan(Integer value) {
            addCriterion("alarm <", value, "alarm");
            return (Criteria) this;
        }

        public Criteria andAlarmLessThanOrEqualTo(Integer value) {
            addCriterion("alarm <=", value, "alarm");
            return (Criteria) this;
        }

        public Criteria andAlarmIn(List<Integer> values) {
            addCriterion("alarm in", values, "alarm");
            return (Criteria) this;
        }

        public Criteria andAlarmNotIn(List<Integer> values) {
            addCriterion("alarm not in", values, "alarm");
            return (Criteria) this;
        }

        public Criteria andAlarmBetween(Integer value1, Integer value2) {
            addCriterion("alarm between", value1, value2, "alarm");
            return (Criteria) this;
        }

        public Criteria andAlarmNotBetween(Integer value1, Integer value2) {
            addCriterion("alarm not between", value1, value2, "alarm");
            return (Criteria) this;
        }

        public Criteria andRssiIsNull() {
            addCriterion("rssi is null");
            return (Criteria) this;
        }

        public Criteria andRssiIsNotNull() {
            addCriterion("rssi is not null");
            return (Criteria) this;
        }

        public Criteria andRssiEqualTo(Integer value) {
            addCriterion("rssi =", value, "rssi");
            return (Criteria) this;
        }

        public Criteria andRssiNotEqualTo(Integer value) {
            addCriterion("rssi <>", value, "rssi");
            return (Criteria) this;
        }

        public Criteria andRssiGreaterThan(Integer value) {
            addCriterion("rssi >", value, "rssi");
            return (Criteria) this;
        }

        public Criteria andRssiGreaterThanOrEqualTo(Integer value) {
            addCriterion("rssi >=", value, "rssi");
            return (Criteria) this;
        }

        public Criteria andRssiLessThan(Integer value) {
            addCriterion("rssi <", value, "rssi");
            return (Criteria) this;
        }

        public Criteria andRssiLessThanOrEqualTo(Integer value) {
            addCriterion("rssi <=", value, "rssi");
            return (Criteria) this;
        }

        public Criteria andRssiIn(List<Integer> values) {
            addCriterion("rssi in", values, "rssi");
            return (Criteria) this;
        }

        public Criteria andRssiNotIn(List<Integer> values) {
            addCriterion("rssi not in", values, "rssi");
            return (Criteria) this;
        }

        public Criteria andRssiBetween(Integer value1, Integer value2) {
            addCriterion("rssi between", value1, value2, "rssi");
            return (Criteria) this;
        }

        public Criteria andRssiNotBetween(Integer value1, Integer value2) {
            addCriterion("rssi not between", value1, value2, "rssi");
            return (Criteria) this;
        }

        public Criteria andManagerIsNull() {
            addCriterion("manager is null");
            return (Criteria) this;
        }

        public Criteria andManagerIsNotNull() {
            addCriterion("manager is not null");
            return (Criteria) this;
        }

        public Criteria andManagerEqualTo(String value) {
            addCriterion("manager =", value, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerNotEqualTo(String value) {
            addCriterion("manager <>", value, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerGreaterThan(String value) {
            addCriterion("manager >", value, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerGreaterThanOrEqualTo(String value) {
            addCriterion("manager >=", value, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerLessThan(String value) {
            addCriterion("manager <", value, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerLessThanOrEqualTo(String value) {
            addCriterion("manager <=", value, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerLike(String value) {
            addCriterion("manager like", value, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerNotLike(String value) {
            addCriterion("manager not like", value, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerIn(List<String> values) {
            addCriterion("manager in", values, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerNotIn(List<String> values) {
            addCriterion("manager not in", values, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerBetween(String value1, String value2) {
            addCriterion("manager between", value1, value2, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerNotBetween(String value1, String value2) {
            addCriterion("manager not between", value1, value2, "manager");
            return (Criteria) this;
        }

        public Criteria andShopkeeperIsNull() {
            addCriterion("shopkeeper is null");
            return (Criteria) this;
        }

        public Criteria andShopkeeperIsNotNull() {
            addCriterion("shopkeeper is not null");
            return (Criteria) this;
        }

        public Criteria andShopkeeperEqualTo(String value) {
            addCriterion("shopkeeper =", value, "shopkeeper");
            return (Criteria) this;
        }

        public Criteria andShopkeeperNotEqualTo(String value) {
            addCriterion("shopkeeper <>", value, "shopkeeper");
            return (Criteria) this;
        }

        public Criteria andShopkeeperGreaterThan(String value) {
            addCriterion("shopkeeper >", value, "shopkeeper");
            return (Criteria) this;
        }

        public Criteria andShopkeeperGreaterThanOrEqualTo(String value) {
            addCriterion("shopkeeper >=", value, "shopkeeper");
            return (Criteria) this;
        }

        public Criteria andShopkeeperLessThan(String value) {
            addCriterion("shopkeeper <", value, "shopkeeper");
            return (Criteria) this;
        }

        public Criteria andShopkeeperLessThanOrEqualTo(String value) {
            addCriterion("shopkeeper <=", value, "shopkeeper");
            return (Criteria) this;
        }

        public Criteria andShopkeeperLike(String value) {
            addCriterion("shopkeeper like", value, "shopkeeper");
            return (Criteria) this;
        }

        public Criteria andShopkeeperNotLike(String value) {
            addCriterion("shopkeeper not like", value, "shopkeeper");
            return (Criteria) this;
        }

        public Criteria andShopkeeperIn(List<String> values) {
            addCriterion("shopkeeper in", values, "shopkeeper");
            return (Criteria) this;
        }

        public Criteria andShopkeeperNotIn(List<String> values) {
            addCriterion("shopkeeper not in", values, "shopkeeper");
            return (Criteria) this;
        }

        public Criteria andShopkeeperBetween(String value1, String value2) {
            addCriterion("shopkeeper between", value1, value2, "shopkeeper");
            return (Criteria) this;
        }

        public Criteria andShopkeeperNotBetween(String value1, String value2) {
            addCriterion("shopkeeper not between", value1, value2, "shopkeeper");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}